	
/****** Object:  Stored Procedure ShippingStatusReportUpdate    Script Date: Friday, January 04, 2008 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spShippingStatusReportUpdate]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [spShippingStatusReportUpdate]
GO

	
	

	
/******************************************************************************
**		File: 
**		Name: spShippingStatusReportUpdate
**		Desc: 
**
**		Return values:
** 
**		Called by:   
**              
**		Parameters:
**		Input							Output
**     ----------							-----------
**
**		Auth: CodeSmith
**		Date: 1/4/2008 3:57:05 PM
*******************************************************************************
**		Change History
*******************************************************************************
**		Date:		Author:				Description:
**		--------		--------				-------------------------------------------
**    
*******************************************************************************/
CREATE PROCEDURE spShippingStatusReportUpdate
	@ID int, 
	@REQ int, 
	@OrderDate datetime, 
	@ContainerSize varchar(50), 
	@LP char(1), 
	@PONo_Office char(4), 
	@PONo_Type char(1), 
	@PONo_Supplier varchar(3), 
	@PONo_Number int, 
	@IsPrimary char(1), 
	@PONo_Consolidation int, 
	@AccNo varchar(7), 
	@CustomerOrLocation nvarchar(30), 
	@FinalDestination nvarchar(30), 
	@Description nvarchar(50), 
	@FactoryETD datetime, 
	@ShippingDate datetime, 
	@ShippingLine varchar(255), 
	@Vessel nvarchar(30), 
	@ContainerNo varchar(16), 
	@ETA datetime, 
	@Week int, 
	@ArrivalPort nvarchar(30), 
	@PI varchar(12), 
	@Payment char(1), 
	@DocReceived bit, 
	@CompletedDate datetime, 
	@BulkType varchar(2), 
	@ModifiedDate datetime, 
	@BulkOrderNo int, 
	@PayAuth char(2), 
	@ContainerDeliveried datetime, 
	@POInOpera datetime, 
	@InvValue money, 
	@PayDate datetime, 
	@Remarks nvarchar(90), 
	@SInvoiced int, 
	@SuppOrderNo varchar(6), 
	@OfficeID int, 
	@CustPONo varchar(12), 
	@OnHold bit, 
	@BulkOrderOfficeID int, 
	@SInvoicedPd datetime, 
	@Catalogue nvarchar(9), 
	@ShippingLineID int, 
	@CatalogID int, 
	@PDepValue money, 
	@SalesInvoiceValue money, 
	@SalesInvoiceDate datetime, 
	@SalesPaymentDue datetime, 
	@SalesOrder int, 
	@TargetETD datetime, 
	@IsArchived bit, 
	@ResponsibleID int, 
	@FactoryETDEnteredDate datetime 
AS

UPDATE [ShippingStatusReport] SET
	[REQ] = @REQ,
	[OrderDate] = @OrderDate,
	[ContainerSize] = @ContainerSize,
	[LP] = @LP,
	[PONo_Office] = @PONo_Office,
	[PONo_Type] = @PONo_Type,
	[PONo_Supplier] = @PONo_Supplier,
	[PONo_Number] = @PONo_Number,
	[IsPrimary] = @IsPrimary,
	[PONo_Consolidation] = @PONo_Consolidation,
	[AccNo] = @AccNo,
	[CustomerOrLocation] = @CustomerOrLocation,
	[FinalDestination] = @FinalDestination,
	[Description] = @Description,
	[FactoryETD] = @FactoryETD,
	[ShippingDate] = @ShippingDate,
	[ShippingLine] = @ShippingLine,
	[Vessel] = @Vessel,
	[ContainerNo] = @ContainerNo,
	[ETA] = @ETA,
	[Week] = @Week,
	[ArrivalPort] = @ArrivalPort,
	[PI] = @PI,
	[Payment] = @Payment,
	[DocReceived] = @DocReceived,
	[CompletedDate] = @CompletedDate,
	[BulkType] = @BulkType,
	[ModifiedDate] = @ModifiedDate,
	[BulkOrderNo] = @BulkOrderNo,
	[PayAuth] = @PayAuth,
	[ContainerDeliveried] = @ContainerDeliveried,
	[POInOpera] = @POInOpera,
	[InvValue] = @InvValue,
	[PayDate] = @PayDate,
	[Remarks] = @Remarks,
	[SInvoiced] = @SInvoiced,
	[SuppOrderNo] = @SuppOrderNo,
	[OfficeID] = @OfficeID,
	[CustPONo] = @CustPONo,
	[OnHold] = @OnHold,
	[BulkOrderOfficeID] = @BulkOrderOfficeID,
	[SInvoicedPd] = @SInvoicedPd,
	[Catalogue] = @Catalogue,
	[ShippingLineID] = @ShippingLineID,
	[CatalogID] = @CatalogID,
	[PDepValue] = @PDepValue,
	[SalesInvoiceValue] = @SalesInvoiceValue,
	[SalesInvoiceDate] = @SalesInvoiceDate,
	[SalesPaymentDue] = @SalesPaymentDue,
	[SalesOrder] = @SalesOrder,
	[TargetETD] = @TargetETD,
	[IsArchived] = @IsArchived,
	[ResponsibleID] = @ResponsibleID,
	[FactoryETDEnteredDate] = @FactoryETDEnteredDate
WHERE
	[ID] = @ID

GO
